﻿using FreeSql.DatabaseModel;using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Reflection;
using System.Threading.Tasks;
using Newtonsoft.Json;
using FreeSql.DataAnnotations;

namespace PropertyManagementSystemAPI.Models {

	[JsonObject(MemberSerialization.OptIn), Table(Name = "cell_assets", DisableSyncStructure = true)]
	public partial class CellAssets {

		/// <summary>
		/// 资产编号
		/// </summary>
		[JsonProperty, Column(Name = "CA_Id", DbType = "int", IsPrimary = true, IsIdentity = true)]
		public int CAId { get; set; }

		/// <summary>
		/// 设备品牌
		/// </summary>
		[JsonProperty, Column(Name = "CA_Brand", StringLength = 50)]
		public string CABrand { get; set; }

		/// <summary>
		/// 购买时间
		/// </summary>
		[JsonProperty, Column(Name = "CA_BuyTime", DbType = "datetime")]
		public DateTime? CABuyTime { get; set; }

		/// <summary>
		///  所属小区
		/// </summary>
		[JsonProperty, Column(Name = "CA_Cell_Id", DbType = "int")]
		public int? CACellId { get; set; }

		/// <summary>
		/// 设备数量
		/// </summary>
		[JsonProperty, Column(Name = "CA_Count", DbType = "int")]
		public int? CACount { get; set; }

		/// <summary>
		/// 创建时间
		/// </summary>
		[JsonProperty, Column(Name = "CA_CreateTime", DbType = "datetime")]
		public DateTime? CACreateTime { get; set; }

		/// <summary>
		/// 设备名
		/// </summary>
		[JsonProperty, Column(Name = "CA_Name", StringLength = 50)]
		public string CAName { get; set; }

		/// <summary>
		/// 设备单价
		/// </summary>
		[JsonProperty, Column(Name = "CA_Price", DbType = "decimal(20,2)")]
		public decimal? CAPrice { get; set; }

		/// <summary>
		/// 预计使用年限
		/// </summary>
		[JsonProperty, Column(Name = "CA_UserYear", DbType = "int")]
		public int? CAUserYear { get; set; }

	}

}
